UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dHLBO1ePgcQLYA3WA4YWdJa1M4sHMfwiA23WYBUaRiU='
WHERE
key_id = '5d589f7497cef97c5d68b8ed6a8b9d3258a4735635fe58b5ce5d26b46ee1662f'
AND (
token = 'dHLBO1ePgcQLYA3WA4YWdJa1M4sHMfwiA23WYBUaRiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)