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