UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nVoinlHl7VGDt5zjBeLZQx2dt8+2TV/6eygXVpQLnZY=' 
WHERE 
  key_id = '5f988144ad6c3a0845526efd9f76196784a98cb2448adae1d31e0b0b06bd400c' 
  AND (
    token = 'nVoinlHl7VGDt5zjBeLZQx2dt8+2TV/6eygXVpQLnZY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028