UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCrVNt0mWIqP4vdMQfQSy1X9UIDk/3PcE/z/09fRcP8='
WHERE
key_id = 'a295a1f7ed2a3b6cdb75688cd440fd7d2d696649628f01814eb0c6d0adcdd581'
AND (
token = 'VCrVNt0mWIqP4vdMQfQSy1X9UIDk/3PcE/z/09fRcP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)