UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H/K3rtENUMf4O4qPfLsX3rFS5rrm73onX1U7SAmwdns='
WHERE
key_id = 'c3f78f71259d00e8a64bad0f57322b83635be5368f5a3127820a8b55caa3fd2c'
AND (
token = 'H/K3rtENUMf4O4qPfLsX3rFS5rrm73onX1U7SAmwdns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)