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