UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FqcdN8j1jkvT+bSk0Q4SJYhQ5kkC29e2dq2R2Q/mIEI='
WHERE
key_id = 'bf84c5aaf26d51e36d9237fcf094da0b060db47727bd0297196ab87ae99efb33'
AND (
token = 'FqcdN8j1jkvT+bSk0Q4SJYhQ5kkC29e2dq2R2Q/mIEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)