UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yq3jrOy95VCMt0JmknkjOQS9EGErOOSYaMWq7P0DFyE='
WHERE
key_id = '3924d98bd46e7453199e8fb6544a7ddf4e39791dd81d7f493612f70ec42b9d15'
AND (
token = 'Yq3jrOy95VCMt0JmknkjOQS9EGErOOSYaMWq7P0DFyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)