UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LZ7zd60/2ysM15YyuW8Hi5uRzexp80jyI8/ojLl7DVg=' 
WHERE 
  key_id = '5493e07707083df72acf5e233b8fde1fed53c0d45e7c2f52c8902cd4893d955f' 
  AND (
    token = 'LZ7zd60/2ysM15YyuW8Hi5uRzexp80jyI8/ojLl7DVg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034