UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AH+sE7/OD3ReiMVaBIqcP2WoeI8HhXA7naapO/34cow=' 
WHERE 
  key_id = '8411ce89e4a4cbe630c7d236dcfd4ec4c1c98a2154ec21c6ccedc3b0cf583cd8' 
  AND (
    token = 'AH+sE7/OD3ReiMVaBIqcP2WoeI8HhXA7naapO/34cow=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049