UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BlbaCXQKOAQ+vVC9RVaYjr9duQQi45ssDeAG0yPnY78='
WHERE
key_id = '7f4970d8ea35257269246b89e70ae8fa0c28b83ad7d5c7f3d33cadd14becd232'
AND (
token = 'BlbaCXQKOAQ+vVC9RVaYjr9duQQi45ssDeAG0yPnY78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)