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