UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kcrxQg4UMn+Du62xwcI6wJMceby/iPdYWQLf/3GdbC8='
WHERE
key_id = 'f59694a1a75abf337c3a14c0f7665048aa5a4a7d9728c8225b3ca0b9f39106ca'
AND (
token = 'kcrxQg4UMn+Du62xwcI6wJMceby/iPdYWQLf/3GdbC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)