UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4pqJsGYmAhPKvQzvjSGHrS2F3HVUZz3T2xVBwuoa/BI='
WHERE
key_id = '9bfb8074cec4b6f063eeaa1c32e87c7a02e09db77c5cafa0c3c7a67aad53190f'
AND (
token = '4pqJsGYmAhPKvQzvjSGHrS2F3HVUZz3T2xVBwuoa/BI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)