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