UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjYb9SjQmFX7Yz7c5THkWIc6YniaczjOa+Oc4LPKfMs='
WHERE
key_id = 'd277cbc94f1e54a92db46bd4cabcaaad5980d47594388df4ee90b887441a83f0'
AND (
token = 'BjYb9SjQmFX7Yz7c5THkWIc6YniaczjOa+Oc4LPKfMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)