UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQJD83I1PV1FZjij0T8BAbhE162XnAQ7Oajv0jAEHhE='
WHERE
key_id = 'bfcae3f1115aaf6409feb14ab13f4149303769de57a45b4de0a9e9d0a658e083'
AND (
token = 'HQJD83I1PV1FZjij0T8BAbhE162XnAQ7Oajv0jAEHhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)