UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6cOB5jNjhrO6rcEjILRSm5dOchG8ou60yjyc7DOLbVs='
WHERE
key_id = '1b488112ac335a45c5b4bc952a8d95573c7fab9854b0039a1f85e33c0b4721af'
AND (
token = '6cOB5jNjhrO6rcEjILRSm5dOchG8ou60yjyc7DOLbVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)