UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mKs2cd9SIRli4gzV40/aJk2csSZWDyUMCESNVVFKEgM='
WHERE
key_id = 'c5b542282bc2fcc3ecc59d0a0ebb752f853079751c97c174e2edc3bdb1850c79'
AND (
token = 'mKs2cd9SIRli4gzV40/aJk2csSZWDyUMCESNVVFKEgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)