UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NfL/A3ZZuO70c5zAtS07vJQG2mXnjkVK6GXnbMCCKCA='
WHERE
key_id = 'c1b92dead70f73776ca2acee4bb0d6e395b315b9b79320e1b9215ef384296a7d'
AND (
token = 'NfL/A3ZZuO70c5zAtS07vJQG2mXnjkVK6GXnbMCCKCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)