UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YET5x1wD0hxAe6lU6Ng5xsAbGd9XhWbjduf/ye5pTmk=' 
WHERE 
  key_id = 'b0e53dbbc8d217d02aecbdcfda44e75ed8fb6ffddb631807d5bf6d43e52f5383' 
  AND (
    token = 'YET5x1wD0hxAe6lU6Ng5xsAbGd9XhWbjduf/ye5pTmk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037