UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VuGTYfyQqPzLKmsEoX96lZm3Qjnu0QWCzF0gHZlS+sY='
WHERE
key_id = '1605b494ac6a6f5e108654099ccab36a2b8666bee8b74caf79576fadff123c3c'
AND (
token = 'VuGTYfyQqPzLKmsEoX96lZm3Qjnu0QWCzF0gHZlS+sY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)