UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QE6gXxEvxfmw+AMsd9IwnDpFU9NI0Vt6Ka5jqqf3RxE='
WHERE
key_id = 'b2d4ee66d253e23f652f7434dba27b3fb78e1e96676f3e190f1dee88ddcf5a6d'
AND (
token = 'QE6gXxEvxfmw+AMsd9IwnDpFU9NI0Vt6Ka5jqqf3RxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)