UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tmf7yH3+7VpQTFvDgRqP2KlQ3KYS/kQr0rP7+6OjIUg='
WHERE
key_id = 'e016c21ac5641b52a3dc875ab0e3e8b649b8a49393a94c0c998abdbeea991e1c'
AND (
token = 'Tmf7yH3+7VpQTFvDgRqP2KlQ3KYS/kQr0rP7+6OjIUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)