UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ZA3PkD7AMfvCPb3RoJhPUFFAcnHoxfYeF9Lb9rAWrc='
WHERE
key_id = 'f65555951052e96573cef7fa5f3262c526b828c4dface21814af5729a01b77b4'
AND (
token = '6ZA3PkD7AMfvCPb3RoJhPUFFAcnHoxfYeF9Lb9rAWrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)