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