UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PpZtjXYqdp4fKKfhUJX/7uiBbwIMqnT3IWE3YrN1Ab4='
WHERE
key_id = 'fc6b5b1f3995fe412eaa7c78e4fb265d9ac1e6ac378c34b645fe7b69f4685457'
AND (
token = 'PpZtjXYqdp4fKKfhUJX/7uiBbwIMqnT3IWE3YrN1Ab4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)