UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWCG7L09uFU1h/wtvYKw1lQ8pTovUnaosbiRSZ8hvgI='
WHERE
key_id = 'f2c3abb71c8440fee9f3c02d1371297cb8eda227aab7ba04f46606f8afac3321'
AND (
token = 'ZWCG7L09uFU1h/wtvYKw1lQ8pTovUnaosbiRSZ8hvgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)