UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e7c3/eQSzcf/atNWiPtDtqlH4FaO0f4b1LsuFpVelUM='
WHERE
key_id = '39a0d7d540624e8c29b03d709a1adc782955c8b89d0beea3e8c355b60de1cb40'
AND (
token = 'e7c3/eQSzcf/atNWiPtDtqlH4FaO0f4b1LsuFpVelUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)