UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G2eZh7W86ej3ONJjxfrTe3/CfQuzyXQD4LLFFSylg4g='
WHERE
key_id = 'bfb549f32fc22b01fed9b381aa06c7d6d63811965741e121d65ddc35e5e4007a'
AND (
token = 'G2eZh7W86ej3ONJjxfrTe3/CfQuzyXQD4LLFFSylg4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)