UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'thZoTIipKwvTR3ulrl7f8wdDDsAuFpsJM03dGZYcukc='
WHERE
key_id = 'fafb1e8da69bfa2953663c54a4c79f5b25d0bf612e4fd3c51da4be4eb685ebea'
AND (
token = 'thZoTIipKwvTR3ulrl7f8wdDDsAuFpsJM03dGZYcukc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)