UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4SHK9LWZrRdHEAOW5FTxAJLRY7YRcjpqd9kzb7fZhP4='
WHERE
key_id = '276f7434e9863164b25f64041d91974ddfde182b3344939982d695e506ec8ea2'
AND (
token = '4SHK9LWZrRdHEAOW5FTxAJLRY7YRcjpqd9kzb7fZhP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)