UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BN4N6lmEL0bWKpUGuOm7QBSFJv0nct6Rz20iicAFmNQ='
WHERE
key_id = '5403f163cb791f911ac8628f05bd94c6053b8401595ed8221fe0cc6f0c87ede4'
AND (
token = 'BN4N6lmEL0bWKpUGuOm7QBSFJv0nct6Rz20iicAFmNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)