UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JXg8IQ9XWt6AFYCcbgDaOq2P1MitBaz9uU2GoNxs7o8='
WHERE
key_id = '0f9aa9947564f8f6dbec72d23138a2275d3bab46d07c025526c4a1fb6b9df6a1'
AND (
token = 'JXg8IQ9XWt6AFYCcbgDaOq2P1MitBaz9uU2GoNxs7o8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)