UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQbsvPrHqnNKyJ3VMOl0a5oYWeqzinNRck2p7pt06vw='
WHERE
key_id = 'db651bfd05cbcac090debaf1bfa145f212832d95df39b85a1304f5e25262e2b9'
AND (
token = 'zQbsvPrHqnNKyJ3VMOl0a5oYWeqzinNRck2p7pt06vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)